﻿CREATE PROCEDURE [dbo].[UpdateMilestone]
@MilestoneID INT, @ProjectID INT, @TargetDate DATETIME, @Description VARCHAR (500), @DollarAmount MONEY, @HasBeenMet BIT
AS
UPDATE Milestones
SET		ProjectID = @ProjectID,
		TargetDate = @TargetDate,
		Description = @Description,
		DollarAmount = @DollarAmount,
		HasBeenMet = @HasBeenMet
WHERE	MilestoneID = @MilestoneID


